{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "eadf3e3d-e531-4bcc-9a62-00392eb6a965",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "8f582445-8f91-4127-8aca-22c6da7a59ba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.advViewFlag</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterName</th>\n",
       "      <th>recruiter.recruiterTitle</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>%7B%22jobId%22%3A%2256376837%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"56376837\",\"userId\":\"4e54ac2e3b974628...</td>\n",
       "      <td>['客户端产品', '工具产品', '供应链产品', '基金产品', 'IT互联网', '金...</td>\n",
       "      <td>56376837</td>\n",
       "      <td>C端高级产品经理(J10043)</td>\n",
       "      <td>2</td>\n",
       "      <td>15-30k·15薪</td>\n",
       "      <td>True</td>\n",
       "      <td>20230621091013</td>\n",
       "      <td>...</td>\n",
       "      <td>王先生</td>\n",
       "      <td>人力资源伙伴(HRBP)</td>\n",
       "      <td>5f8f986aea60860b75384fab08u.jpg</td>\n",
       "      <td>9954019.0</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>盈米基金</td>\n",
       "      <td>B轮</td>\n",
       "      <td>5e38f3e729d83a67544619cd08u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/9954019/</td>\n",
       "      <td>基金/证券/期货</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>%7B%22jobId%22%3A%2258733143%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"58733143\",\"userId\":\"32232aca46ec9ae7...</td>\n",
       "      <td>[]</td>\n",
       "      <td>58733143</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>2</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>True</td>\n",
       "      <td>20230619103414</td>\n",
       "      <td>...</td>\n",
       "      <td>李女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>8094471.0</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>辉柏嘉(中国)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5fdc38169b3439706a19fd5901u.png</td>\n",
       "      <td>https://www.liepin.com/company/8094471/</td>\n",
       "      <td>办公用品/设备</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>%7B%22jobId%22%3A%2258956493%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"58956493\",\"userId\":\"df48f523e5944ace...</td>\n",
       "      <td>[]</td>\n",
       "      <td>58956493</td>\n",
       "      <td>Product Marketing Manager</td>\n",
       "      <td>2</td>\n",
       "      <td>18-25k·14薪</td>\n",
       "      <td>True</td>\n",
       "      <td>20230616103702</td>\n",
       "      <td>...</td>\n",
       "      <td>黄女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>7977404.0</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>卡尔蔡司光学(广州)有限公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>648fbf95b7732f1e292621c406u.png</td>\n",
       "      <td>https://www.liepin.com/company/7977404/</td>\n",
       "      <td>批发/零售</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>%7B%22jobId%22%3A%2250965433%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"50965433\",\"userId\":\"14799e1bef289c70...</td>\n",
       "      <td>['英语', '市场推广', '市场拓展', '渠道策划', '市场策划', '市场调研分析...</td>\n",
       "      <td>50965433</td>\n",
       "      <td>产品经理（化妆品原料）/Product Manager</td>\n",
       "      <td>2</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>False</td>\n",
       "      <td>20230621113158</td>\n",
       "      <td>...</td>\n",
       "      <td>吴女士</td>\n",
       "      <td>HR Officer</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>8112968.0</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>仙婷集团</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6274ee6d04a5ff469b10880402u.png</td>\n",
       "      <td>https://www.liepin.com/company/8112968/</td>\n",
       "      <td>贸易/进出口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>%7B%22jobId%22%3A%2257679297%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"57679297\",\"userId\":\"74207202b9a1882c...</td>\n",
       "      <td>['数据产品', '工具产品', '平台产品', '科研/技术服务', '数据分析', 'S...</td>\n",
       "      <td>57679297</td>\n",
       "      <td>产品经理Product Manager</td>\n",
       "      <td>2</td>\n",
       "      <td>20-25k</td>\n",
       "      <td>False</td>\n",
       "      <td>20230410215438</td>\n",
       "      <td>...</td>\n",
       "      <td>樊女士</td>\n",
       "      <td>HRM</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>13315477.0</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广州市新目标电子商务有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13315477/</td>\n",
       "      <td>IT服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>35</td>\n",
       "      <td>%7B%22jobId%22%3A%2245177357%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"45177357\",\"recruiterName\":\"孙女士\",\"job...</td>\n",
       "      <td>['市场营销', '产品管理', '产品开发']</td>\n",
       "      <td>45177357</td>\n",
       "      <td>Product Manager</td>\n",
       "      <td>1</td>\n",
       "      <td>25-30k</td>\n",
       "      <td>False</td>\n",
       "      <td>20230621104001</td>\n",
       "      <td>...</td>\n",
       "      <td>孙女士</td>\n",
       "      <td>猎头顾问</td>\n",
       "      <td>6321be3095ee1c04143439eb01u.jpeg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>某国内大型快消品公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>60e2fe0bf3df194a3c48adb502u.png</td>\n",
       "      <td>NaN</td>\n",
       "      <td>日化</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>836</th>\n",
       "      <td>36</td>\n",
       "      <td>%7B%22jobId%22%3A%2259115121%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"59115121\",\"recruiterName\":\"陈女士\",\"job...</td>\n",
       "      <td>['市场洞察', '拓展培训', '团队管理', '销售管理', '出差']</td>\n",
       "      <td>59115121</td>\n",
       "      <td>微生物检测产品经理（制药行业/双休）</td>\n",
       "      <td>2</td>\n",
       "      <td>15-20k·16薪</td>\n",
       "      <td>False</td>\n",
       "      <td>20230606134705</td>\n",
       "      <td>...</td>\n",
       "      <td>陈女士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>7932064.0</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广东环凯微生物科技有限公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>5bfe8edd74719d35745a548603a.png</td>\n",
       "      <td>https://www.liepin.com/company/7932064/</td>\n",
       "      <td>制药</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>37</td>\n",
       "      <td>%7B%22jobId%22%3A%2257403583%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"57403583\",\"recruiterName\":\"俞女士\",\"job...</td>\n",
       "      <td>['CRM软件', '信息化项目', '软件行业', '咨询项目', '售前支持', '服务...</td>\n",
       "      <td>57403583</td>\n",
       "      <td>CRM实施顾问&amp;项目经理PM(J12971)</td>\n",
       "      <td>2</td>\n",
       "      <td>11-22k</td>\n",
       "      <td>False</td>\n",
       "      <td>20230329180701</td>\n",
       "      <td>...</td>\n",
       "      <td>俞女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>601baaab60c8320221e3c1d902u.png</td>\n",
       "      <td>8361671.0</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>上海汉得信息技术股份有限公司</td>\n",
       "      <td>已上市</td>\n",
       "      <td>5ed700f4ec4db462f82e4ddf01u.png</td>\n",
       "      <td>https://www.liepin.com/company/8361671/</td>\n",
       "      <td>互联网</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>38</td>\n",
       "      <td>%7B%22jobId%22%3A%2255992453%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"55992453\",\"recruiterName\":\"郑先生\",\"job...</td>\n",
       "      <td>['品牌策划']</td>\n",
       "      <td>55992453</td>\n",
       "      <td>产品策划经理</td>\n",
       "      <td>2</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>False</td>\n",
       "      <td>20230520104442</td>\n",
       "      <td>...</td>\n",
       "      <td>郑先生</td>\n",
       "      <td>HRM</td>\n",
       "      <td>5f8f9868f6d1ab58476f24a008u.jpg</td>\n",
       "      <td>9660700.0</td>\n",
       "      <td>1000-2000人</td>\n",
       "      <td>嫚熙控股(广州)有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5f30a76e556e7a7b1280cc3006u.png</td>\n",
       "      <td>https://www.liepin.com/company/9660700/</td>\n",
       "      <td>互联网</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>39</td>\n",
       "      <td>%7B%22jobId%22%3A%2245327891%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"45327891\",\"recruiterName\":\"唐女士\",\"job...</td>\n",
       "      <td>[]</td>\n",
       "      <td>45327891</td>\n",
       "      <td>硬件产品经理</td>\n",
       "      <td>1</td>\n",
       "      <td>30-50k·14薪</td>\n",
       "      <td>False</td>\n",
       "      <td>20230425143147</td>\n",
       "      <td>...</td>\n",
       "      <td>唐女士</td>\n",
       "      <td>猎头顾问</td>\n",
       "      <td>5f8fa3bddfb13a7dee343d7608u.png</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>某广州电气机械/器材公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60e2fe0bf3df194a3c48adb502u.png</td>\n",
       "      <td>NaN</td>\n",
       "      <td>电气机械/器材</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>840 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                                           dataInfo  \\\n",
       "0             0  %7B%22jobId%22%3A%2256376837%22%2C%22d_curPage...   \n",
       "1             1  %7B%22jobId%22%3A%2258733143%22%2C%22d_curPage...   \n",
       "2             2  %7B%22jobId%22%3A%2258956493%22%2C%22d_curPage...   \n",
       "3             3  %7B%22jobId%22%3A%2250965433%22%2C%22d_curPage...   \n",
       "4             4  %7B%22jobId%22%3A%2257679297%22%2C%22d_curPage...   \n",
       "..          ...                                                ...   \n",
       "835          35  %7B%22jobId%22%3A%2245177357%22%2C%22d_curPage...   \n",
       "836          36  %7B%22jobId%22%3A%2259115121%22%2C%22d_curPage...   \n",
       "837          37  %7B%22jobId%22%3A%2257403583%22%2C%22d_curPage...   \n",
       "838          38  %7B%22jobId%22%3A%2255992453%22%2C%22d_curPage...   \n",
       "839          39  %7B%22jobId%22%3A%2245327891%22%2C%22d_curPage...   \n",
       "\n",
       "                                            dataParams  \\\n",
       "0    {\"jobId\":\"56376837\",\"userId\":\"4e54ac2e3b974628...   \n",
       "1    {\"jobId\":\"58733143\",\"userId\":\"32232aca46ec9ae7...   \n",
       "2    {\"jobId\":\"58956493\",\"userId\":\"df48f523e5944ace...   \n",
       "3    {\"jobId\":\"50965433\",\"userId\":\"14799e1bef289c70...   \n",
       "4    {\"jobId\":\"57679297\",\"userId\":\"74207202b9a1882c...   \n",
       "..                                                 ...   \n",
       "835  {\"jobId\":\"45177357\",\"recruiterName\":\"孙女士\",\"job...   \n",
       "836  {\"jobId\":\"59115121\",\"recruiterName\":\"陈女士\",\"job...   \n",
       "837  {\"jobId\":\"57403583\",\"recruiterName\":\"俞女士\",\"job...   \n",
       "838  {\"jobId\":\"55992453\",\"recruiterName\":\"郑先生\",\"job...   \n",
       "839  {\"jobId\":\"45327891\",\"recruiterName\":\"唐女士\",\"job...   \n",
       "\n",
       "                                            job.labels  job.jobId  \\\n",
       "0    ['客户端产品', '工具产品', '供应链产品', '基金产品', 'IT互联网', '金...   56376837   \n",
       "1                                                   []   58733143   \n",
       "2                                                   []   58956493   \n",
       "3    ['英语', '市场推广', '市场拓展', '渠道策划', '市场策划', '市场调研分析...   50965433   \n",
       "4    ['数据产品', '工具产品', '平台产品', '科研/技术服务', '数据分析', 'S...   57679297   \n",
       "..                                                 ...        ...   \n",
       "835                           ['市场营销', '产品管理', '产品开发']   45177357   \n",
       "836             ['市场洞察', '拓展培训', '团队管理', '销售管理', '出差']   59115121   \n",
       "837  ['CRM软件', '信息化项目', '软件行业', '咨询项目', '售前支持', '服务...   57403583   \n",
       "838                                           ['品牌策划']   55992453   \n",
       "839                                                 []   45327891   \n",
       "\n",
       "                       job.title  job.jobKind  job.salary  job.advViewFlag  \\\n",
       "0               C端高级产品经理(J10043)            2  15-30k·15薪             True   \n",
       "1                           产品经理            2        薪资面议             True   \n",
       "2      Product Marketing Manager            2  18-25k·14薪             True   \n",
       "3    产品经理（化妆品原料）/Product Manager            2        薪资面议            False   \n",
       "4            产品经理Product Manager            2      20-25k            False   \n",
       "..                           ...          ...         ...              ...   \n",
       "835             Product Manager             1      25-30k            False   \n",
       "836           微生物检测产品经理（制药行业/双休）            2  15-20k·16薪            False   \n",
       "837       CRM实施顾问&项目经理PM(J12971)            2      11-22k            False   \n",
       "838                       产品策划经理            2      15-25k            False   \n",
       "839                       硬件产品经理            1  30-50k·14薪            False   \n",
       "\n",
       "     job.refreshTime  ... recruiter.recruiterName  recruiter.recruiterTitle  \\\n",
       "0     20230621091013  ...                     王先生              人力资源伙伴(HRBP)   \n",
       "1     20230619103414  ...                     李女士                        HR   \n",
       "2     20230616103702  ...                     黄女士                        HR   \n",
       "3     20230621113158  ...                     吴女士                HR Officer   \n",
       "4     20230410215438  ...                     樊女士                       HRM   \n",
       "..               ...  ...                     ...                       ...   \n",
       "835   20230621104001  ...                     孙女士                      猎头顾问   \n",
       "836   20230606134705  ...                     陈女士                       NaN   \n",
       "837   20230329180701  ...                     俞女士                        HR   \n",
       "838   20230520104442  ...                     郑先生                       HRM   \n",
       "839   20230425143147  ...                     唐女士                      猎头顾问   \n",
       "\n",
       "             recruiter.recruiterPhoto  comp.compId  comp.compScale  \\\n",
       "0     5f8f986aea60860b75384fab08u.jpg    9954019.0        100-499人   \n",
       "1     5f8f986779c7cc70efbf36c008u.jpg    8094471.0        500-999人   \n",
       "2     5f8f9865ea60860b75384fa508u.jpg    7977404.0        500-999人   \n",
       "3     5f8f98648dbe6273dcf8515508u.jpg    8112968.0          50-99人   \n",
       "4     5f8f9863f6d1ab58476f246a08u.jpg   13315477.0        100-499人   \n",
       "..                                ...          ...             ...   \n",
       "835  6321be3095ee1c04143439eb01u.jpeg          NaN      2000-5000人   \n",
       "836   5f8f98648dbe6273dcf8515508u.jpg    7932064.0        100-499人   \n",
       "837   601baaab60c8320221e3c1d902u.png    8361671.0        10000人以上   \n",
       "838   5f8f9868f6d1ab58476f24a008u.jpg    9660700.0      1000-2000人   \n",
       "839   5f8fa3bddfb13a7dee343d7608u.png          NaN           1-49人   \n",
       "\n",
       "      comp.compName comp.compStage                    comp.compLogo  \\\n",
       "0              盈米基金             B轮  5e38f3e729d83a67544619cd08u.jpg   \n",
       "1           辉柏嘉(中国)            NaN  5fdc38169b3439706a19fd5901u.png   \n",
       "2    卡尔蔡司光学(广州)有限公司          融资未公开  648fbf95b7732f1e292621c406u.png   \n",
       "3              仙婷集团            NaN  6274ee6d04a5ff469b10880402u.png   \n",
       "4    广州市新目标电子商务有限公司            NaN  61b07937d0458d53c627567e02u.jpg   \n",
       "..              ...            ...                              ...   \n",
       "835      某国内大型快消品公司          融资未公开  60e2fe0bf3df194a3c48adb502u.png   \n",
       "836   广东环凯微生物科技有限公司          融资未公开  5bfe8edd74719d35745a548603a.png   \n",
       "837  上海汉得信息技术股份有限公司            已上市  5ed700f4ec4db462f82e4ddf01u.png   \n",
       "838    嫚熙控股(广州)有限公司            NaN  5f30a76e556e7a7b1280cc3006u.png   \n",
       "839    某广州电气机械/器材公司            NaN  60e2fe0bf3df194a3c48adb502u.png   \n",
       "\n",
       "                                    comp.link comp.compIndustry  \n",
       "0     https://www.liepin.com/company/9954019/          基金/证券/期货  \n",
       "1     https://www.liepin.com/company/8094471/           办公用品/设备  \n",
       "2     https://www.liepin.com/company/7977404/             批发/零售  \n",
       "3     https://www.liepin.com/company/8112968/            贸易/进出口  \n",
       "4    https://www.liepin.com/company/13315477/              IT服务  \n",
       "..                                        ...               ...  \n",
       "835                                       NaN                日化  \n",
       "836   https://www.liepin.com/company/7932064/                制药  \n",
       "837   https://www.liepin.com/company/8361671/               互联网  \n",
       "838   https://www.liepin.com/company/9660700/               互联网  \n",
       "839                                       NaN           电气机械/器材  \n",
       "\n",
       "[840 rows x 32 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_excel('liepin_PM_0510.xlsx')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "95f2d402-8fc7-445a-8514-86bff3b663c0",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/l3/qb66j_w51vqdx0lr5h8jv2qh0000gn/T/ipykernel_35580/3536731137.py:1: FutureWarning: In a future version of pandas all arguments of DataFrame.drop except for the argument 'labels' will be keyword-only.\n",
      "  df = df.drop('Unnamed: 0',1)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.advViewFlag</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterName</th>\n",
       "      <th>recruiter.recruiterTitle</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>%7B%22jobId%22%3A%2256376837%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"56376837\",\"userId\":\"4e54ac2e3b974628...</td>\n",
       "      <td>['客户端产品', '工具产品', '供应链产品', '基金产品', 'IT互联网', '金...</td>\n",
       "      <td>56376837</td>\n",
       "      <td>C端高级产品经理(J10043)</td>\n",
       "      <td>2</td>\n",
       "      <td>15-30k·15薪</td>\n",
       "      <td>True</td>\n",
       "      <td>20230621091013</td>\n",
       "      <td>广州</td>\n",
       "      <td>...</td>\n",
       "      <td>王先生</td>\n",
       "      <td>人力资源伙伴(HRBP)</td>\n",
       "      <td>5f8f986aea60860b75384fab08u.jpg</td>\n",
       "      <td>9954019.0</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>盈米基金</td>\n",
       "      <td>B轮</td>\n",
       "      <td>5e38f3e729d83a67544619cd08u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/9954019/</td>\n",
       "      <td>基金/证券/期货</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>%7B%22jobId%22%3A%2258733143%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"58733143\",\"userId\":\"32232aca46ec9ae7...</td>\n",
       "      <td>[]</td>\n",
       "      <td>58733143</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>2</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>True</td>\n",
       "      <td>20230619103414</td>\n",
       "      <td>广州</td>\n",
       "      <td>...</td>\n",
       "      <td>李女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>8094471.0</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>辉柏嘉(中国)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5fdc38169b3439706a19fd5901u.png</td>\n",
       "      <td>https://www.liepin.com/company/8094471/</td>\n",
       "      <td>办公用品/设备</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>%7B%22jobId%22%3A%2258956493%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"58956493\",\"userId\":\"df48f523e5944ace...</td>\n",
       "      <td>[]</td>\n",
       "      <td>58956493</td>\n",
       "      <td>Product Marketing Manager</td>\n",
       "      <td>2</td>\n",
       "      <td>18-25k·14薪</td>\n",
       "      <td>True</td>\n",
       "      <td>20230616103702</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>...</td>\n",
       "      <td>黄女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>7977404.0</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>卡尔蔡司光学(广州)有限公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>648fbf95b7732f1e292621c406u.png</td>\n",
       "      <td>https://www.liepin.com/company/7977404/</td>\n",
       "      <td>批发/零售</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>%7B%22jobId%22%3A%2250965433%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"50965433\",\"userId\":\"14799e1bef289c70...</td>\n",
       "      <td>['英语', '市场推广', '市场拓展', '渠道策划', '市场策划', '市场调研分析...</td>\n",
       "      <td>50965433</td>\n",
       "      <td>产品经理（化妆品原料）/Product Manager</td>\n",
       "      <td>2</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>False</td>\n",
       "      <td>20230621113158</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>...</td>\n",
       "      <td>吴女士</td>\n",
       "      <td>HR Officer</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>8112968.0</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>仙婷集团</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6274ee6d04a5ff469b10880402u.png</td>\n",
       "      <td>https://www.liepin.com/company/8112968/</td>\n",
       "      <td>贸易/进出口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>%7B%22jobId%22%3A%2257679297%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"57679297\",\"userId\":\"74207202b9a1882c...</td>\n",
       "      <td>['数据产品', '工具产品', '平台产品', '科研/技术服务', '数据分析', 'S...</td>\n",
       "      <td>57679297</td>\n",
       "      <td>产品经理Product Manager</td>\n",
       "      <td>2</td>\n",
       "      <td>20-25k</td>\n",
       "      <td>False</td>\n",
       "      <td>20230410215438</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>...</td>\n",
       "      <td>樊女士</td>\n",
       "      <td>HRM</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>13315477.0</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广州市新目标电子商务有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13315477/</td>\n",
       "      <td>IT服务</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>%7B%22jobId%22%3A%2245177357%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"45177357\",\"recruiterName\":\"孙女士\",\"job...</td>\n",
       "      <td>['市场营销', '产品管理', '产品开发']</td>\n",
       "      <td>45177357</td>\n",
       "      <td>Product Manager</td>\n",
       "      <td>1</td>\n",
       "      <td>25-30k</td>\n",
       "      <td>False</td>\n",
       "      <td>20230621104001</td>\n",
       "      <td>广州</td>\n",
       "      <td>...</td>\n",
       "      <td>孙女士</td>\n",
       "      <td>猎头顾问</td>\n",
       "      <td>6321be3095ee1c04143439eb01u.jpeg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>某国内大型快消品公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>60e2fe0bf3df194a3c48adb502u.png</td>\n",
       "      <td>NaN</td>\n",
       "      <td>日化</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>836</th>\n",
       "      <td>%7B%22jobId%22%3A%2259115121%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"59115121\",\"recruiterName\":\"陈女士\",\"job...</td>\n",
       "      <td>['市场洞察', '拓展培训', '团队管理', '销售管理', '出差']</td>\n",
       "      <td>59115121</td>\n",
       "      <td>微生物检测产品经理（制药行业/双休）</td>\n",
       "      <td>2</td>\n",
       "      <td>15-20k·16薪</td>\n",
       "      <td>False</td>\n",
       "      <td>20230606134705</td>\n",
       "      <td>广州-黄埔区</td>\n",
       "      <td>...</td>\n",
       "      <td>陈女士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>7932064.0</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广东环凯微生物科技有限公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>5bfe8edd74719d35745a548603a.png</td>\n",
       "      <td>https://www.liepin.com/company/7932064/</td>\n",
       "      <td>制药</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>%7B%22jobId%22%3A%2257403583%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"57403583\",\"recruiterName\":\"俞女士\",\"job...</td>\n",
       "      <td>['CRM软件', '信息化项目', '软件行业', '咨询项目', '售前支持', '服务...</td>\n",
       "      <td>57403583</td>\n",
       "      <td>CRM实施顾问&amp;项目经理PM(J12971)</td>\n",
       "      <td>2</td>\n",
       "      <td>11-22k</td>\n",
       "      <td>False</td>\n",
       "      <td>20230329180701</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>...</td>\n",
       "      <td>俞女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>601baaab60c8320221e3c1d902u.png</td>\n",
       "      <td>8361671.0</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>上海汉得信息技术股份有限公司</td>\n",
       "      <td>已上市</td>\n",
       "      <td>5ed700f4ec4db462f82e4ddf01u.png</td>\n",
       "      <td>https://www.liepin.com/company/8361671/</td>\n",
       "      <td>互联网</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>%7B%22jobId%22%3A%2255992453%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"55992453\",\"recruiterName\":\"郑先生\",\"job...</td>\n",
       "      <td>['品牌策划']</td>\n",
       "      <td>55992453</td>\n",
       "      <td>产品策划经理</td>\n",
       "      <td>2</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>False</td>\n",
       "      <td>20230520104442</td>\n",
       "      <td>广州-白云区</td>\n",
       "      <td>...</td>\n",
       "      <td>郑先生</td>\n",
       "      <td>HRM</td>\n",
       "      <td>5f8f9868f6d1ab58476f24a008u.jpg</td>\n",
       "      <td>9660700.0</td>\n",
       "      <td>1000-2000人</td>\n",
       "      <td>嫚熙控股(广州)有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5f30a76e556e7a7b1280cc3006u.png</td>\n",
       "      <td>https://www.liepin.com/company/9660700/</td>\n",
       "      <td>互联网</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>%7B%22jobId%22%3A%2245327891%22%2C%22d_curPage...</td>\n",
       "      <td>{\"jobId\":\"45327891\",\"recruiterName\":\"唐女士\",\"job...</td>\n",
       "      <td>[]</td>\n",
       "      <td>45327891</td>\n",
       "      <td>硬件产品经理</td>\n",
       "      <td>1</td>\n",
       "      <td>30-50k·14薪</td>\n",
       "      <td>False</td>\n",
       "      <td>20230425143147</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>...</td>\n",
       "      <td>唐女士</td>\n",
       "      <td>猎头顾问</td>\n",
       "      <td>5f8fa3bddfb13a7dee343d7608u.png</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>某广州电气机械/器材公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60e2fe0bf3df194a3c48adb502u.png</td>\n",
       "      <td>NaN</td>\n",
       "      <td>电气机械/器材</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>840 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              dataInfo  \\\n",
       "0    %7B%22jobId%22%3A%2256376837%22%2C%22d_curPage...   \n",
       "1    %7B%22jobId%22%3A%2258733143%22%2C%22d_curPage...   \n",
       "2    %7B%22jobId%22%3A%2258956493%22%2C%22d_curPage...   \n",
       "3    %7B%22jobId%22%3A%2250965433%22%2C%22d_curPage...   \n",
       "4    %7B%22jobId%22%3A%2257679297%22%2C%22d_curPage...   \n",
       "..                                                 ...   \n",
       "835  %7B%22jobId%22%3A%2245177357%22%2C%22d_curPage...   \n",
       "836  %7B%22jobId%22%3A%2259115121%22%2C%22d_curPage...   \n",
       "837  %7B%22jobId%22%3A%2257403583%22%2C%22d_curPage...   \n",
       "838  %7B%22jobId%22%3A%2255992453%22%2C%22d_curPage...   \n",
       "839  %7B%22jobId%22%3A%2245327891%22%2C%22d_curPage...   \n",
       "\n",
       "                                            dataParams  \\\n",
       "0    {\"jobId\":\"56376837\",\"userId\":\"4e54ac2e3b974628...   \n",
       "1    {\"jobId\":\"58733143\",\"userId\":\"32232aca46ec9ae7...   \n",
       "2    {\"jobId\":\"58956493\",\"userId\":\"df48f523e5944ace...   \n",
       "3    {\"jobId\":\"50965433\",\"userId\":\"14799e1bef289c70...   \n",
       "4    {\"jobId\":\"57679297\",\"userId\":\"74207202b9a1882c...   \n",
       "..                                                 ...   \n",
       "835  {\"jobId\":\"45177357\",\"recruiterName\":\"孙女士\",\"job...   \n",
       "836  {\"jobId\":\"59115121\",\"recruiterName\":\"陈女士\",\"job...   \n",
       "837  {\"jobId\":\"57403583\",\"recruiterName\":\"俞女士\",\"job...   \n",
       "838  {\"jobId\":\"55992453\",\"recruiterName\":\"郑先生\",\"job...   \n",
       "839  {\"jobId\":\"45327891\",\"recruiterName\":\"唐女士\",\"job...   \n",
       "\n",
       "                                            job.labels  job.jobId  \\\n",
       "0    ['客户端产品', '工具产品', '供应链产品', '基金产品', 'IT互联网', '金...   56376837   \n",
       "1                                                   []   58733143   \n",
       "2                                                   []   58956493   \n",
       "3    ['英语', '市场推广', '市场拓展', '渠道策划', '市场策划', '市场调研分析...   50965433   \n",
       "4    ['数据产品', '工具产品', '平台产品', '科研/技术服务', '数据分析', 'S...   57679297   \n",
       "..                                                 ...        ...   \n",
       "835                           ['市场营销', '产品管理', '产品开发']   45177357   \n",
       "836             ['市场洞察', '拓展培训', '团队管理', '销售管理', '出差']   59115121   \n",
       "837  ['CRM软件', '信息化项目', '软件行业', '咨询项目', '售前支持', '服务...   57403583   \n",
       "838                                           ['品牌策划']   55992453   \n",
       "839                                                 []   45327891   \n",
       "\n",
       "                       job.title  job.jobKind  job.salary  job.advViewFlag  \\\n",
       "0               C端高级产品经理(J10043)            2  15-30k·15薪             True   \n",
       "1                           产品经理            2        薪资面议             True   \n",
       "2      Product Marketing Manager            2  18-25k·14薪             True   \n",
       "3    产品经理（化妆品原料）/Product Manager            2        薪资面议            False   \n",
       "4            产品经理Product Manager            2      20-25k            False   \n",
       "..                           ...          ...         ...              ...   \n",
       "835             Product Manager             1      25-30k            False   \n",
       "836           微生物检测产品经理（制药行业/双休）            2  15-20k·16薪            False   \n",
       "837       CRM实施顾问&项目经理PM(J12971)            2      11-22k            False   \n",
       "838                       产品策划经理            2      15-25k            False   \n",
       "839                       硬件产品经理            1  30-50k·14薪            False   \n",
       "\n",
       "     job.refreshTime  job.dq  ...  recruiter.recruiterName  \\\n",
       "0     20230621091013      广州  ...                      王先生   \n",
       "1     20230619103414      广州  ...                      李女士   \n",
       "2     20230616103702  广州-天河区  ...                      黄女士   \n",
       "3     20230621113158  广州-天河区  ...                      吴女士   \n",
       "4     20230410215438  广州-番禺区  ...                      樊女士   \n",
       "..               ...     ...  ...                      ...   \n",
       "835   20230621104001      广州  ...                      孙女士   \n",
       "836   20230606134705  广州-黄埔区  ...                      陈女士   \n",
       "837   20230329180701  广州-番禺区  ...                      俞女士   \n",
       "838   20230520104442  广州-白云区  ...                      郑先生   \n",
       "839   20230425143147  广州-海珠区  ...                      唐女士   \n",
       "\n",
       "    recruiter.recruiterTitle          recruiter.recruiterPhoto  comp.compId  \\\n",
       "0               人力资源伙伴(HRBP)   5f8f986aea60860b75384fab08u.jpg    9954019.0   \n",
       "1                         HR   5f8f986779c7cc70efbf36c008u.jpg    8094471.0   \n",
       "2                         HR   5f8f9865ea60860b75384fa508u.jpg    7977404.0   \n",
       "3                 HR Officer   5f8f98648dbe6273dcf8515508u.jpg    8112968.0   \n",
       "4                        HRM   5f8f9863f6d1ab58476f246a08u.jpg   13315477.0   \n",
       "..                       ...                               ...          ...   \n",
       "835                     猎头顾问  6321be3095ee1c04143439eb01u.jpeg          NaN   \n",
       "836                      NaN   5f8f98648dbe6273dcf8515508u.jpg    7932064.0   \n",
       "837                       HR   601baaab60c8320221e3c1d902u.png    8361671.0   \n",
       "838                      HRM   5f8f9868f6d1ab58476f24a008u.jpg    9660700.0   \n",
       "839                     猎头顾问   5f8fa3bddfb13a7dee343d7608u.png          NaN   \n",
       "\n",
       "    comp.compScale   comp.compName comp.compStage  \\\n",
       "0         100-499人            盈米基金             B轮   \n",
       "1         500-999人         辉柏嘉(中国)            NaN   \n",
       "2         500-999人  卡尔蔡司光学(广州)有限公司          融资未公开   \n",
       "3           50-99人            仙婷集团            NaN   \n",
       "4         100-499人  广州市新目标电子商务有限公司            NaN   \n",
       "..             ...             ...            ...   \n",
       "835     2000-5000人      某国内大型快消品公司          融资未公开   \n",
       "836       100-499人   广东环凯微生物科技有限公司          融资未公开   \n",
       "837       10000人以上  上海汉得信息技术股份有限公司            已上市   \n",
       "838     1000-2000人    嫚熙控股(广州)有限公司            NaN   \n",
       "839          1-49人    某广州电气机械/器材公司            NaN   \n",
       "\n",
       "                       comp.compLogo  \\\n",
       "0    5e38f3e729d83a67544619cd08u.jpg   \n",
       "1    5fdc38169b3439706a19fd5901u.png   \n",
       "2    648fbf95b7732f1e292621c406u.png   \n",
       "3    6274ee6d04a5ff469b10880402u.png   \n",
       "4    61b07937d0458d53c627567e02u.jpg   \n",
       "..                               ...   \n",
       "835  60e2fe0bf3df194a3c48adb502u.png   \n",
       "836  5bfe8edd74719d35745a548603a.png   \n",
       "837  5ed700f4ec4db462f82e4ddf01u.png   \n",
       "838  5f30a76e556e7a7b1280cc3006u.png   \n",
       "839  60e2fe0bf3df194a3c48adb502u.png   \n",
       "\n",
       "                                    comp.link  comp.compIndustry  \n",
       "0     https://www.liepin.com/company/9954019/           基金/证券/期货  \n",
       "1     https://www.liepin.com/company/8094471/            办公用品/设备  \n",
       "2     https://www.liepin.com/company/7977404/              批发/零售  \n",
       "3     https://www.liepin.com/company/8112968/             贸易/进出口  \n",
       "4    https://www.liepin.com/company/13315477/               IT服务  \n",
       "..                                        ...                ...  \n",
       "835                                       NaN                 日化  \n",
       "836   https://www.liepin.com/company/7932064/                 制药  \n",
       "837   https://www.liepin.com/company/8361671/                互联网  \n",
       "838   https://www.liepin.com/company/9660700/                互联网  \n",
       "839                                       NaN            电气机械/器材  \n",
       "\n",
       "[840 rows x 31 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.drop('Unnamed: 0',1)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1e3b3ed2-00d0-44f3-872a-19df0ce49eb3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>job.requireEduLevel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>['客户端产品', '工具产品', '供应链产品', '基金产品', 'IT互联网', '金...</td>\n",
       "      <td>C端高级产品经理(J10043)</td>\n",
       "      <td>15-30k·15薪</td>\n",
       "      <td>广州</td>\n",
       "      <td>True</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>盈米基金</td>\n",
       "      <td>基金/证券/期货</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>本科</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>辉柏嘉(中国)</td>\n",
       "      <td>办公用品/设备</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>统招本科</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[]</td>\n",
       "      <td>Product Marketing Manager</td>\n",
       "      <td>18-25k·14薪</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>卡尔蔡司光学(广州)有限公司</td>\n",
       "      <td>批发/零售</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>硕士</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>['英语', '市场推广', '市场拓展', '渠道策划', '市场策划', '市场调研分析...</td>\n",
       "      <td>产品经理（化妆品原料）/Product Manager</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>仙婷集团</td>\n",
       "      <td>贸易/进出口</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>硕士</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>['数据产品', '工具产品', '平台产品', '科研/技术服务', '数据分析', 'S...</td>\n",
       "      <td>产品经理Product Manager</td>\n",
       "      <td>20-25k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>广州市新目标电子商务有限公司</td>\n",
       "      <td>IT服务</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>本科</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>['市场营销', '产品管理', '产品开发']</td>\n",
       "      <td>Product Manager</td>\n",
       "      <td>25-30k</td>\n",
       "      <td>广州</td>\n",
       "      <td>False</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>某国内大型快消品公司</td>\n",
       "      <td>日化</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>本科及以上</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>836</th>\n",
       "      <td>['市场洞察', '拓展培训', '团队管理', '销售管理', '出差']</td>\n",
       "      <td>微生物检测产品经理（制药行业/双休）</td>\n",
       "      <td>15-20k·16薪</td>\n",
       "      <td>广州-黄埔区</td>\n",
       "      <td>False</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>广东环凯微生物科技有限公司</td>\n",
       "      <td>制药</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>统招本科</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>['CRM软件', '信息化项目', '软件行业', '咨询项目', '售前支持', '服务...</td>\n",
       "      <td>CRM实施顾问&amp;项目经理PM(J12971)</td>\n",
       "      <td>11-22k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>上海汉得信息技术股份有限公司</td>\n",
       "      <td>互联网</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>本科</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>['品牌策划']</td>\n",
       "      <td>产品策划经理</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-白云区</td>\n",
       "      <td>False</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>嫚熙控股(广州)有限公司</td>\n",
       "      <td>互联网</td>\n",
       "      <td>1000-2000人</td>\n",
       "      <td>本科</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>[]</td>\n",
       "      <td>硬件产品经理</td>\n",
       "      <td>30-50k·14薪</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>False</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>某广州电气机械/器材公司</td>\n",
       "      <td>电气机械/器材</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>本科及以上</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>840 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            job.labels  \\\n",
       "0    ['客户端产品', '工具产品', '供应链产品', '基金产品', 'IT互联网', '金...   \n",
       "1                                                   []   \n",
       "2                                                   []   \n",
       "3    ['英语', '市场推广', '市场拓展', '渠道策划', '市场策划', '市场调研分析...   \n",
       "4    ['数据产品', '工具产品', '平台产品', '科研/技术服务', '数据分析', 'S...   \n",
       "..                                                 ...   \n",
       "835                           ['市场营销', '产品管理', '产品开发']   \n",
       "836             ['市场洞察', '拓展培训', '团队管理', '销售管理', '出差']   \n",
       "837  ['CRM软件', '信息化项目', '软件行业', '咨询项目', '售前支持', '服务...   \n",
       "838                                           ['品牌策划']   \n",
       "839                                                 []   \n",
       "\n",
       "                       job.title  job.salary  job.dq  job.topJob  \\\n",
       "0               C端高级产品经理(J10043)  15-30k·15薪      广州        True   \n",
       "1                           产品经理        薪资面议      广州        True   \n",
       "2      Product Marketing Manager  18-25k·14薪  广州-天河区        True   \n",
       "3    产品经理（化妆品原料）/Product Manager        薪资面议  广州-天河区       False   \n",
       "4            产品经理Product Manager      20-25k  广州-番禺区       False   \n",
       "..                           ...         ...     ...         ...   \n",
       "835             Product Manager       25-30k      广州       False   \n",
       "836           微生物检测产品经理（制药行业/双休）  15-20k·16薪  广州-黄埔区       False   \n",
       "837       CRM实施顾问&项目经理PM(J12971)      11-22k  广州-番禺区       False   \n",
       "838                       产品策划经理      15-25k  广州-白云区       False   \n",
       "839                       硬件产品经理  30-50k·14薪  广州-海珠区       False   \n",
       "\n",
       "    job.requireWorkYears   comp.compName comp.compIndustry comp.compScale  \\\n",
       "0                   3-5年            盈米基金          基金/证券/期货       100-499人   \n",
       "1                  5-10年         辉柏嘉(中国)           办公用品/设备       500-999人   \n",
       "2                  5-10年  卡尔蔡司光学(广州)有限公司             批发/零售       500-999人   \n",
       "3                   3-5年            仙婷集团            贸易/进出口         50-99人   \n",
       "4                   3-5年  广州市新目标电子商务有限公司              IT服务       100-499人   \n",
       "..                   ...             ...               ...            ...   \n",
       "835                 1-3年      某国内大型快消品公司                日化     2000-5000人   \n",
       "836                5-10年   广东环凯微生物科技有限公司                制药       100-499人   \n",
       "837                 3-5年  上海汉得信息技术股份有限公司               互联网       10000人以上   \n",
       "838                5-10年    嫚熙控股(广州)有限公司               互联网     1000-2000人   \n",
       "839                5-10年    某广州电气机械/器材公司           电气机械/器材          1-49人   \n",
       "\n",
       "    job.requireEduLevel  \n",
       "0                    本科  \n",
       "1                  统招本科  \n",
       "2                    硕士  \n",
       "3                    硕士  \n",
       "4                    本科  \n",
       "..                  ...  \n",
       "835               本科及以上  \n",
       "836                统招本科  \n",
       "837                  本科  \n",
       "838                  本科  \n",
       "839               本科及以上  \n",
       "\n",
       "[840 rows x 10 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_PM = df[['job.labels','job.title','job.salary','job.dq','job.topJob','job.requireWorkYears','comp.compName','comp.compIndustry','comp.compScale','job.requireEduLevel']]\n",
    "df_PM"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9289d462-836d-4aae-9940-5f61c4bba967",
   "metadata": {},
   "source": [
    "# 数据可视化分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "f4bd8096-03b4-41ba-b194-62ff86a0bedd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['天河区', '番禺区', '越秀区', '白云区', '海珠区', '南沙区', '黄埔区']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州地区 = [  i.split('-')[1]       for i in df_PM['job.dq'].value_counts().index.tolist()[1:]]\n",
    "广州地区"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "f5785280-40eb-416c-a2d4-7c40944063af",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[252, 79, 63, 63, 34, 21, 21]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州_岗位数量 = df_PM['job.dq'].value_counts().values.tolist()[1:]\n",
    "广州_岗位数量"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0a73a8ca-faab-4ae5-b182-61aa63eddb20",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts':'https://assets.pyecharts.org/assets/v5/echarts.min', '广州':'https://assets.pyecharts.org/assets/v5/maps/guang3_dong1_guang3_zhou1'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "        <div id=\"98b0d4c5d7384863abb1c4c7479d3f6c\" style=\"width:900px; height:500px;\"></div>\n",
       "\n",
       "<script>\n",
       "        require(['echarts', '广州'], function(echarts) {\n",
       "                var chart_98b0d4c5d7384863abb1c4c7479d3f6c = echarts.init(\n",
       "                    document.getElementById('98b0d4c5d7384863abb1c4c7479d3f6c'), 'white', {renderer: 'canvas'});\n",
       "                var option_98b0d4c5d7384863abb1c4c7479d3f6c = {\n",
       "    \"animation\": true,\n",
       "    \"animationThreshold\": 2000,\n",
       "    \"animationDuration\": 1000,\n",
       "    \"animationEasing\": \"cubicOut\",\n",
       "    \"animationDelay\": 0,\n",
       "    \"animationDurationUpdate\": 300,\n",
       "    \"animationEasingUpdate\": \"cubicOut\",\n",
       "    \"animationDelayUpdate\": 0,\n",
       "    \"aria\": {\n",
       "        \"enabled\": false\n",
       "    },\n",
       "    \"color\": [\n",
       "        \"#5470c6\",\n",
       "        \"#91cc75\",\n",
       "        \"#fac858\",\n",
       "        \"#ee6666\",\n",
       "        \"#73c0de\",\n",
       "        \"#3ba272\",\n",
       "        \"#fc8452\",\n",
       "        \"#9a60b4\",\n",
       "        \"#ea7ccc\"\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"map\",\n",
       "            \"name\": \"\\u5546\\u5bb6A\",\n",
       "            \"label\": {\n",
       "                \"show\": true,\n",
       "                \"margin\": 8\n",
       "            },\n",
       "            \"map\": \"\\u5e7f\\u5dde\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u5929\\u6cb3\\u533a\",\n",
       "                    \"value\": 252\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u756a\\u79ba\\u533a\",\n",
       "                    \"value\": 79\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8d8a\\u79c0\\u533a\",\n",
       "                    \"value\": 63\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u767d\\u4e91\\u533a\",\n",
       "                    \"value\": 63\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6d77\\u73e0\\u533a\",\n",
       "                    \"value\": 34\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5357\\u6c99\\u533a\",\n",
       "                    \"value\": 21\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u9ec4\\u57d4\\u533a\",\n",
       "                    \"value\": 21\n",
       "                }\n",
       "            ],\n",
       "            \"roam\": true,\n",
       "            \"aspectScale\": 0.75,\n",
       "            \"nameProperty\": \"name\",\n",
       "            \"selectedMode\": false,\n",
       "            \"zoom\": 1,\n",
       "            \"zlevel\": 0,\n",
       "            \"z\": 2,\n",
       "            \"seriesLayoutBy\": \"column\",\n",
       "            \"datasetIndex\": 0,\n",
       "            \"mapValueCalculation\": \"sum\",\n",
       "            \"showLegendSymbol\": true,\n",
       "            \"emphasis\": {}\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5546\\u5bb6A\"\n",
       "            ],\n",
       "            \"selected\": {},\n",
       "            \"show\": true,\n",
       "            \"padding\": 5,\n",
       "            \"itemGap\": 10,\n",
       "            \"itemWidth\": 25,\n",
       "            \"itemHeight\": 14,\n",
       "            \"backgroundColor\": \"transparent\",\n",
       "            \"borderColor\": \"#ccc\",\n",
       "            \"borderWidth\": 1,\n",
       "            \"borderRadius\": 0,\n",
       "            \"pageButtonItemGap\": 5,\n",
       "            \"pageButtonPosition\": \"end\",\n",
       "            \"pageFormatter\": \"{current}/{total}\",\n",
       "            \"pageIconColor\": \"#2f4554\",\n",
       "            \"pageIconInactiveColor\": \"#aaa\",\n",
       "            \"pageIconSize\": 15,\n",
       "            \"animationDurationUpdate\": 800,\n",
       "            \"selector\": false,\n",
       "            \"selectorPosition\": \"auto\",\n",
       "            \"selectorItemGap\": 7,\n",
       "            \"selectorButtonGap\": 10\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"show\": true,\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"showContent\": true,\n",
       "        \"alwaysShowContent\": false,\n",
       "        \"showDelay\": 0,\n",
       "        \"hideDelay\": 100,\n",
       "        \"enterable\": false,\n",
       "        \"confine\": false,\n",
       "        \"appendToBody\": false,\n",
       "        \"transitionDuration\": 0.4,\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0,\n",
       "        \"padding\": 5,\n",
       "        \"order\": \"seriesAsc\"\n",
       "    },\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"text\": \"Map-\\u5e7f\\u5dde\\u5730\\u56fe\",\n",
       "            \"target\": \"blank\",\n",
       "            \"subtarget\": \"blank\",\n",
       "            \"padding\": 5,\n",
       "            \"itemGap\": 10,\n",
       "            \"textAlign\": \"auto\",\n",
       "            \"textVerticalAlign\": \"auto\",\n",
       "            \"triggerEvent\": false\n",
       "        }\n",
       "    ],\n",
       "    \"visualMap\": {\n",
       "        \"show\": true,\n",
       "        \"type\": \"continuous\",\n",
       "        \"min\": 0,\n",
       "        \"max\": 100,\n",
       "        \"inRange\": {\n",
       "            \"color\": [\n",
       "                \"#50a3ba\",\n",
       "                \"#eac763\",\n",
       "                \"#d94e5d\"\n",
       "            ]\n",
       "        },\n",
       "        \"calculable\": true,\n",
       "        \"inverse\": false,\n",
       "        \"splitNumber\": 5,\n",
       "        \"hoverLink\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"padding\": 5,\n",
       "        \"showLabel\": true,\n",
       "        \"itemWidth\": 20,\n",
       "        \"itemHeight\": 140,\n",
       "        \"borderWidth\": 0\n",
       "    }\n",
       "};\n",
       "                chart_98b0d4c5d7384863abb1c4c7479d3f6c.setOption(option_98b0d4c5d7384863abb1c4c7479d3f6c);\n",
       "        });\n",
       "    </script>\n"
      ],
      "text/plain": [
       "<pyecharts.render.display.HTML at 0x7fc2b1e80160>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 可视化：以可视化工具数据形态符合的数据进行输入\n",
    "\n",
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import Map\n",
    "from pyecharts.faker import Faker\n",
    "\n",
    "c = (\n",
    "    Map()\n",
    "    .add(\"商家A\", [list(z) for z in zip(广州地区, 广州_岗位数量)], \"广州\")\n",
    "    .set_global_opts(\n",
    "        title_opts=opts.TitleOpts(title=\"Map-广州地图\"), visualmap_opts=opts.VisualMapOpts()\n",
    "    )\n",
    "    \n",
    ")\n",
    "c.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "455f8c56-b7bd-4e9f-9f10-40f529ae735c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      ['客户端产品', '工具产品', '供应链产品', '基金产品', 'IT互联网', '金...\n",
       "1                                                     []\n",
       "2                                                     []\n",
       "3      ['英语', '市场推广', '市场拓展', '渠道策划', '市场策划', '市场调研分析...\n",
       "4      ['数据产品', '工具产品', '平台产品', '科研/技术服务', '数据分析', 'S...\n",
       "                             ...                        \n",
       "835                             ['市场营销', '产品管理', '产品开发']\n",
       "836               ['市场洞察', '拓展培训', '团队管理', '销售管理', '出差']\n",
       "837    ['CRM软件', '信息化项目', '软件行业', '咨询项目', '售前支持', '服务...\n",
       "838                                             ['品牌策划']\n",
       "839                                                   []\n",
       "Name: job.labels, Length: 840, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_PM['job.labels']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ef108072-a34a-47ce-aa52-e82951e85632",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['客户端产品',\n",
       " '工具产品',\n",
       " '供应链产品',\n",
       " '基金产品',\n",
       " 'IT互联网',\n",
       " '金融理财/贷款',\n",
       " 'to C',\n",
       " 'to B',\n",
       " '产品设计',\n",
       " '移动端产品',\n",
       " '英语',\n",
       " '市场推广',\n",
       " '市场拓展',\n",
       " '渠道策划',\n",
       " '市场策划',\n",
       " '市场调研分析',\n",
       " '乙方公司背景',\n",
       " 'to B',\n",
       " '大客户',\n",
       " '无销售性质',\n",
       " '数据产品',\n",
       " '工具产品',\n",
       " '平台产品',\n",
       " '科研/技术服务',\n",
       " '数据分析',\n",
       " 'SQL',\n",
       " '竞品分析',\n",
       " '中央市场产品经理经验',\n",
       " '区域推广经验',\n",
       " '神外',\n",
       " '医生',\n",
       " '化妆品原料',\n",
       " '市场推广',\n",
       " '产品策划',\n",
       " '产品运营',\n",
       " '产品规划',\n",
       " 'PS',\n",
       " 'PPT',\n",
       " '研讨会',\n",
       " '活性物',\n",
       " '护肤品',\n",
       " '硬件产品',\n",
       " '硬件系统集成',\n",
       " '汽车行业',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '市场调研',\n",
       " '交互设计',\n",
       " '产品规划',\n",
       " '游戏行业',\n",
       " '产品设计',\n",
       " 'AI人工智能产品',\n",
       " 'AI人工智能产品',\n",
       " '内容产品',\n",
       " '商业产品',\n",
       " '人工智能',\n",
       " 'to C',\n",
       " 'IT互联网',\n",
       " 'to G',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '策略产品',\n",
       " '平台产品',\n",
       " '数据产品',\n",
       " '计算机软件',\n",
       " '产品优化',\n",
       " '团队管理',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '数据挖掘',\n",
       " '数据分析',\n",
       " 'b端产品',\n",
       " '用户增长',\n",
       " '策略产品',\n",
       " '数据分析',\n",
       " '内容产品',\n",
       " 'C端产品',\n",
       " '增长黑客',\n",
       " '私域增长',\n",
       " '新零售',\n",
       " '化妆品',\n",
       " '消费品',\n",
       " '产品开发',\n",
       " '产品策略',\n",
       " '爆品',\n",
       " '母婴',\n",
       " '美妆',\n",
       " '产品策划',\n",
       " '电商',\n",
       " 'to C',\n",
       " '商品管理',\n",
       " '产品企划',\n",
       " '商品运营',\n",
       " '医院器械',\n",
       " '泌尿外科',\n",
       " '品牌策划',\n",
       " '市场营销',\n",
       " '产品管理',\n",
       " '产品开发',\n",
       " 'to C',\n",
       " '游戏产品',\n",
       " 'MMO游戏',\n",
       " 'CRM软件',\n",
       " '信息化项目',\n",
       " '软件行业',\n",
       " '咨询项目',\n",
       " '售前支持',\n",
       " '服务业',\n",
       " '批发/零售',\n",
       " 'IT/互联网/软件',\n",
       " '化工行业',\n",
       " 'CRM系统',\n",
       " '市场洞察',\n",
       " '拓展培训',\n",
       " '团队管理',\n",
       " '销售管理',\n",
       " '出差',\n",
       " '产品优化',\n",
       " '二次元在研',\n",
       " '项目管理',\n",
       " '增长产品',\n",
       " '数据分析',\n",
       " '客户端产品',\n",
       " '工具产品',\n",
       " '供应链产品',\n",
       " '基金产品',\n",
       " 'IT互联网',\n",
       " '金融理财/贷款',\n",
       " 'to C',\n",
       " 'to B',\n",
       " '产品设计',\n",
       " '移动端产品',\n",
       " '英语',\n",
       " '市场推广',\n",
       " '市场拓展',\n",
       " '渠道策划',\n",
       " '市场策划',\n",
       " '市场调研分析',\n",
       " '乙方公司背景',\n",
       " 'to B',\n",
       " '大客户',\n",
       " '无销售性质',\n",
       " '数据产品',\n",
       " '工具产品',\n",
       " '平台产品',\n",
       " '科研/技术服务',\n",
       " '数据分析',\n",
       " 'SQL',\n",
       " '竞品分析',\n",
       " '中央市场产品经理经验',\n",
       " '区域推广经验',\n",
       " '神外',\n",
       " '医生',\n",
       " '化妆品原料',\n",
       " '市场推广',\n",
       " '产品策划',\n",
       " '产品运营',\n",
       " '产品规划',\n",
       " 'PS',\n",
       " 'PPT',\n",
       " '研讨会',\n",
       " '活性物',\n",
       " '护肤品',\n",
       " 'to B',\n",
       " 'to G',\n",
       " '硬件产品',\n",
       " '硬件系统集成',\n",
       " '汽车行业',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '市场调研',\n",
       " '交互设计',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " 'AI人工智能产品',\n",
       " '游戏行业',\n",
       " 'to B',\n",
       " 'to G',\n",
       " 'AI人工智能产品',\n",
       " '内容产品',\n",
       " '商业产品',\n",
       " '人工智能',\n",
       " 'to C',\n",
       " 'IT互联网',\n",
       " 'to G',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '策略产品',\n",
       " '平台产品',\n",
       " '数据产品',\n",
       " '计算机软件',\n",
       " '产品优化',\n",
       " '团队管理',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '数据挖掘',\n",
       " '数据分析',\n",
       " '化妆品',\n",
       " '消费品',\n",
       " '产品开发',\n",
       " '产品策略',\n",
       " '爆品',\n",
       " '母婴',\n",
       " '美妆',\n",
       " '产品策划',\n",
       " '电商',\n",
       " 'b端产品',\n",
       " '用户增长',\n",
       " '策略产品',\n",
       " '数据分析',\n",
       " '内容产品',\n",
       " 'C端产品',\n",
       " '增长黑客',\n",
       " '私域增长',\n",
       " '新零售',\n",
       " 'to C',\n",
       " '商品管理',\n",
       " '产品企划',\n",
       " '商品运营',\n",
       " '医院器械',\n",
       " '泌尿外科',\n",
       " '游戏产品',\n",
       " 'MMO游戏',\n",
       " 'to C',\n",
       " '产品优化',\n",
       " '二次元在研',\n",
       " '项目管理',\n",
       " '市场营销',\n",
       " '产品管理',\n",
       " '产品开发',\n",
       " '市场洞察',\n",
       " '拓展培训',\n",
       " '团队管理',\n",
       " '销售管理',\n",
       " '出差',\n",
       " 'CRM软件',\n",
       " '信息化项目',\n",
       " '软件行业',\n",
       " '咨询项目',\n",
       " '售前支持',\n",
       " '服务业',\n",
       " '批发/零售',\n",
       " 'IT/互联网/软件',\n",
       " '化工行业',\n",
       " 'CRM系统',\n",
       " '品牌策划',\n",
       " '客户端产品',\n",
       " '工具产品',\n",
       " '供应链产品',\n",
       " '基金产品',\n",
       " 'IT互联网',\n",
       " '金融理财/贷款',\n",
       " 'to C',\n",
       " 'to B',\n",
       " '产品设计',\n",
       " '移动端产品',\n",
       " '英语',\n",
       " '市场推广',\n",
       " '市场拓展',\n",
       " '渠道策划',\n",
       " '市场策划',\n",
       " '市场调研分析',\n",
       " '乙方公司背景',\n",
       " 'to B',\n",
       " '大客户',\n",
       " '无销售性质',\n",
       " '数据产品',\n",
       " '工具产品',\n",
       " '平台产品',\n",
       " '科研/技术服务',\n",
       " '数据分析',\n",
       " 'SQL',\n",
       " '竞品分析',\n",
       " '中央市场产品经理经验',\n",
       " '区域推广经验',\n",
       " '神外',\n",
       " '医生',\n",
       " '化妆品原料',\n",
       " '市场推广',\n",
       " '产品策划',\n",
       " '产品运营',\n",
       " '产品规划',\n",
       " 'PS',\n",
       " 'PPT',\n",
       " '研讨会',\n",
       " '活性物',\n",
       " '护肤品',\n",
       " '硬件产品',\n",
       " '硬件系统集成',\n",
       " '汽车行业',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '市场调研',\n",
       " '交互设计',\n",
       " '产品规划',\n",
       " '游戏行业',\n",
       " '产品设计',\n",
       " 'AI人工智能产品',\n",
       " 'AI人工智能产品',\n",
       " '内容产品',\n",
       " '商业产品',\n",
       " '人工智能',\n",
       " 'to C',\n",
       " 'IT互联网',\n",
       " 'to G',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '策略产品',\n",
       " '平台产品',\n",
       " '数据产品',\n",
       " '计算机软件',\n",
       " '产品优化',\n",
       " '团队管理',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '数据挖掘',\n",
       " '数据分析',\n",
       " 'b端产品',\n",
       " '用户增长',\n",
       " '策略产品',\n",
       " '数据分析',\n",
       " '内容产品',\n",
       " 'C端产品',\n",
       " '增长黑客',\n",
       " '私域增长',\n",
       " '新零售',\n",
       " '化妆品',\n",
       " '消费品',\n",
       " '产品开发',\n",
       " '产品策略',\n",
       " '爆品',\n",
       " '母婴',\n",
       " '美妆',\n",
       " '产品策划',\n",
       " '电商',\n",
       " 'to C',\n",
       " '商品管理',\n",
       " '产品企划',\n",
       " '商品运营',\n",
       " '医院器械',\n",
       " '泌尿外科',\n",
       " '品牌策划',\n",
       " '市场营销',\n",
       " '产品管理',\n",
       " '产品开发',\n",
       " 'to C',\n",
       " '游戏产品',\n",
       " 'MMO游戏',\n",
       " 'CRM软件',\n",
       " '信息化项目',\n",
       " '软件行业',\n",
       " '咨询项目',\n",
       " '售前支持',\n",
       " '服务业',\n",
       " '批发/零售',\n",
       " 'IT/互联网/软件',\n",
       " '化工行业',\n",
       " 'CRM系统',\n",
       " '市场洞察',\n",
       " '拓展培训',\n",
       " '团队管理',\n",
       " '销售管理',\n",
       " '出差',\n",
       " '产品优化',\n",
       " '二次元在研',\n",
       " '项目管理',\n",
       " '增长产品',\n",
       " '数据分析',\n",
       " '客户端产品',\n",
       " '工具产品',\n",
       " '供应链产品',\n",
       " '基金产品',\n",
       " 'IT互联网',\n",
       " '金融理财/贷款',\n",
       " 'to C',\n",
       " 'to B',\n",
       " '产品设计',\n",
       " '移动端产品',\n",
       " '英语',\n",
       " '市场推广',\n",
       " '市场拓展',\n",
       " '渠道策划',\n",
       " '市场策划',\n",
       " '市场调研分析',\n",
       " '乙方公司背景',\n",
       " 'to B',\n",
       " '大客户',\n",
       " '无销售性质',\n",
       " '数据产品',\n",
       " '工具产品',\n",
       " '平台产品',\n",
       " '科研/技术服务',\n",
       " '数据分析',\n",
       " 'SQL',\n",
       " '竞品分析',\n",
       " '中央市场产品经理经验',\n",
       " '区域推广经验',\n",
       " '神外',\n",
       " '医生',\n",
       " '化妆品原料',\n",
       " '市场推广',\n",
       " '产品策划',\n",
       " '产品运营',\n",
       " '产品规划',\n",
       " 'PS',\n",
       " 'PPT',\n",
       " '研讨会',\n",
       " '活性物',\n",
       " '护肤品',\n",
       " '硬件产品',\n",
       " '硬件系统集成',\n",
       " '汽车行业',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '市场调研',\n",
       " '交互设计',\n",
       " '产品规划',\n",
       " '游戏行业',\n",
       " '产品设计',\n",
       " 'AI人工智能产品',\n",
       " 'AI人工智能产品',\n",
       " '内容产品',\n",
       " '商业产品',\n",
       " '人工智能',\n",
       " 'to C',\n",
       " 'IT互联网',\n",
       " 'to G',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '策略产品',\n",
       " '平台产品',\n",
       " '数据产品',\n",
       " '计算机软件',\n",
       " '产品优化',\n",
       " '团队管理',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '数据挖掘',\n",
       " '数据分析',\n",
       " 'b端产品',\n",
       " '用户增长',\n",
       " '策略产品',\n",
       " '数据分析',\n",
       " '内容产品',\n",
       " 'C端产品',\n",
       " '增长黑客',\n",
       " '私域增长',\n",
       " '新零售',\n",
       " '化妆品',\n",
       " '消费品',\n",
       " '产品开发',\n",
       " '产品策略',\n",
       " '爆品',\n",
       " '母婴',\n",
       " '美妆',\n",
       " '产品策划',\n",
       " '电商',\n",
       " 'to C',\n",
       " '商品管理',\n",
       " '产品企划',\n",
       " '商品运营',\n",
       " '医院器械',\n",
       " '泌尿外科',\n",
       " '品牌策划',\n",
       " '市场营销',\n",
       " '产品管理',\n",
       " '产品开发',\n",
       " 'to C',\n",
       " '游戏产品',\n",
       " 'MMO游戏',\n",
       " 'CRM软件',\n",
       " '信息化项目',\n",
       " '软件行业',\n",
       " '咨询项目',\n",
       " '售前支持',\n",
       " '服务业',\n",
       " '批发/零售',\n",
       " 'IT/互联网/软件',\n",
       " '化工行业',\n",
       " 'CRM系统',\n",
       " '市场洞察',\n",
       " '拓展培训',\n",
       " '团队管理',\n",
       " '销售管理',\n",
       " '出差',\n",
       " '产品优化',\n",
       " '二次元在研',\n",
       " '项目管理',\n",
       " '增长产品',\n",
       " '数据分析',\n",
       " '客户端产品',\n",
       " '工具产品',\n",
       " '供应链产品',\n",
       " '基金产品',\n",
       " 'IT互联网',\n",
       " '金融理财/贷款',\n",
       " 'to C',\n",
       " 'to B',\n",
       " '产品设计',\n",
       " '移动端产品',\n",
       " '英语',\n",
       " '市场推广',\n",
       " '市场拓展',\n",
       " '渠道策划',\n",
       " '市场策划',\n",
       " '市场调研分析',\n",
       " '乙方公司背景',\n",
       " 'to B',\n",
       " '大客户',\n",
       " '无销售性质',\n",
       " '数据产品',\n",
       " '工具产品',\n",
       " '平台产品',\n",
       " '科研/技术服务',\n",
       " '数据分析',\n",
       " 'SQL',\n",
       " '竞品分析',\n",
       " '中央市场产品经理经验',\n",
       " '区域推广经验',\n",
       " '神外',\n",
       " '医生',\n",
       " '化妆品原料',\n",
       " '市场推广',\n",
       " '产品策划',\n",
       " '产品运营',\n",
       " '产品规划',\n",
       " 'PS',\n",
       " 'PPT',\n",
       " '研讨会',\n",
       " '活性物',\n",
       " '护肤品',\n",
       " 'to B',\n",
       " 'to G',\n",
       " '硬件产品',\n",
       " '硬件系统集成',\n",
       " '汽车行业',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '市场调研',\n",
       " '交互设计',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " 'AI人工智能产品',\n",
       " '游戏行业',\n",
       " 'to B',\n",
       " 'to G',\n",
       " 'AI人工智能产品',\n",
       " '内容产品',\n",
       " '商业产品',\n",
       " '人工智能',\n",
       " 'to C',\n",
       " 'IT互联网',\n",
       " 'to G',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '策略产品',\n",
       " '平台产品',\n",
       " '数据产品',\n",
       " '计算机软件',\n",
       " '产品优化',\n",
       " '团队管理',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '数据挖掘',\n",
       " '数据分析',\n",
       " '化妆品',\n",
       " '消费品',\n",
       " '产品开发',\n",
       " '产品策略',\n",
       " '爆品',\n",
       " '母婴',\n",
       " '美妆',\n",
       " '产品策划',\n",
       " '电商',\n",
       " 'b端产品',\n",
       " '用户增长',\n",
       " '策略产品',\n",
       " '数据分析',\n",
       " '内容产品',\n",
       " 'C端产品',\n",
       " '增长黑客',\n",
       " '私域增长',\n",
       " '新零售',\n",
       " 'to C',\n",
       " '商品管理',\n",
       " '产品企划',\n",
       " '商品运营',\n",
       " '医院器械',\n",
       " '泌尿外科',\n",
       " '游戏产品',\n",
       " 'MMO游戏',\n",
       " 'to C',\n",
       " '产品优化',\n",
       " '二次元在研',\n",
       " '项目管理',\n",
       " '市场营销',\n",
       " '产品管理',\n",
       " '产品开发',\n",
       " '市场洞察',\n",
       " '拓展培训',\n",
       " '团队管理',\n",
       " '销售管理',\n",
       " '出差',\n",
       " 'CRM软件',\n",
       " '信息化项目',\n",
       " '软件行业',\n",
       " '咨询项目',\n",
       " '售前支持',\n",
       " '服务业',\n",
       " '批发/零售',\n",
       " 'IT/互联网/软件',\n",
       " '化工行业',\n",
       " 'CRM系统',\n",
       " '品牌策划',\n",
       " '客户端产品',\n",
       " '工具产品',\n",
       " '供应链产品',\n",
       " '基金产品',\n",
       " 'IT互联网',\n",
       " '金融理财/贷款',\n",
       " 'to C',\n",
       " 'to B',\n",
       " '产品设计',\n",
       " '移动端产品',\n",
       " '英语',\n",
       " '市场推广',\n",
       " '市场拓展',\n",
       " '渠道策划',\n",
       " '市场策划',\n",
       " '市场调研分析',\n",
       " '乙方公司背景',\n",
       " 'to B',\n",
       " '大客户',\n",
       " '无销售性质',\n",
       " '数据产品',\n",
       " '工具产品',\n",
       " '平台产品',\n",
       " '科研/技术服务',\n",
       " '数据分析',\n",
       " 'SQL',\n",
       " '竞品分析',\n",
       " '中央市场产品经理经验',\n",
       " '区域推广经验',\n",
       " '神外',\n",
       " '医生',\n",
       " '化妆品原料',\n",
       " '市场推广',\n",
       " '产品策划',\n",
       " '产品运营',\n",
       " '产品规划',\n",
       " 'PS',\n",
       " 'PPT',\n",
       " '研讨会',\n",
       " '活性物',\n",
       " '护肤品',\n",
       " '硬件产品',\n",
       " '硬件系统集成',\n",
       " '汽车行业',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '市场调研',\n",
       " '交互设计',\n",
       " '产品规划',\n",
       " '游戏行业',\n",
       " '产品设计',\n",
       " 'AI人工智能产品',\n",
       " 'AI人工智能产品',\n",
       " '内容产品',\n",
       " '商业产品',\n",
       " '人工智能',\n",
       " 'to C',\n",
       " 'IT互联网',\n",
       " 'to G',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '策略产品',\n",
       " '平台产品',\n",
       " '数据产品',\n",
       " '计算机软件',\n",
       " '产品优化',\n",
       " '团队管理',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '数据挖掘',\n",
       " '数据分析',\n",
       " 'b端产品',\n",
       " '用户增长',\n",
       " '策略产品',\n",
       " '数据分析',\n",
       " '内容产品',\n",
       " 'C端产品',\n",
       " '增长黑客',\n",
       " '私域增长',\n",
       " '新零售',\n",
       " '化妆品',\n",
       " '消费品',\n",
       " '产品开发',\n",
       " '产品策略',\n",
       " '爆品',\n",
       " '母婴',\n",
       " '美妆',\n",
       " '产品策划',\n",
       " '电商',\n",
       " 'to C',\n",
       " '商品管理',\n",
       " '产品企划',\n",
       " '商品运营',\n",
       " '医院器械',\n",
       " '泌尿外科',\n",
       " '品牌策划',\n",
       " '市场营销',\n",
       " '产品管理',\n",
       " '产品开发',\n",
       " 'to C',\n",
       " '游戏产品',\n",
       " 'MMO游戏',\n",
       " 'CRM软件',\n",
       " '信息化项目',\n",
       " '软件行业',\n",
       " '咨询项目',\n",
       " '售前支持',\n",
       " '服务业',\n",
       " '批发/零售',\n",
       " 'IT/互联网/软件',\n",
       " '化工行业',\n",
       " 'CRM系统',\n",
       " '市场洞察',\n",
       " '拓展培训',\n",
       " '团队管理',\n",
       " '销售管理',\n",
       " '出差',\n",
       " '产品优化',\n",
       " '二次元在研',\n",
       " '项目管理',\n",
       " '增长产品',\n",
       " '数据分析',\n",
       " '客户端产品',\n",
       " '工具产品',\n",
       " '供应链产品',\n",
       " '基金产品',\n",
       " 'IT互联网',\n",
       " '金融理财/贷款',\n",
       " 'to C',\n",
       " 'to B',\n",
       " '产品设计',\n",
       " '移动端产品',\n",
       " '英语',\n",
       " '市场推广',\n",
       " '市场拓展',\n",
       " '渠道策划',\n",
       " '市场策划',\n",
       " '市场调研分析',\n",
       " '乙方公司背景',\n",
       " 'to B',\n",
       " '大客户',\n",
       " '无销售性质',\n",
       " '数据产品',\n",
       " '工具产品',\n",
       " '平台产品',\n",
       " '科研/技术服务',\n",
       " '数据分析',\n",
       " 'SQL',\n",
       " '竞品分析',\n",
       " '中央市场产品经理经验',\n",
       " '区域推广经验',\n",
       " '神外',\n",
       " '医生',\n",
       " '化妆品原料',\n",
       " '市场推广',\n",
       " '产品策划',\n",
       " '产品运营',\n",
       " '产品规划',\n",
       " 'PS',\n",
       " 'PPT',\n",
       " '研讨会',\n",
       " '活性物',\n",
       " '护肤品',\n",
       " 'to B',\n",
       " 'to G',\n",
       " '硬件产品',\n",
       " '硬件系统集成',\n",
       " '汽车行业',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '市场调研',\n",
       " '交互设计',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " 'AI人工智能产品',\n",
       " '游戏行业',\n",
       " 'to B',\n",
       " 'to G',\n",
       " 'AI人工智能产品',\n",
       " '内容产品',\n",
       " '商业产品',\n",
       " '人工智能',\n",
       " 'to C',\n",
       " 'IT互联网',\n",
       " 'to G',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '策略产品',\n",
       " '平台产品',\n",
       " '数据产品',\n",
       " '计算机软件',\n",
       " '产品优化',\n",
       " '团队管理',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '数据挖掘',\n",
       " '数据分析',\n",
       " '化妆品',\n",
       " '消费品',\n",
       " '产品开发',\n",
       " '产品策略',\n",
       " '爆品',\n",
       " '母婴',\n",
       " '美妆',\n",
       " '产品策划',\n",
       " '电商',\n",
       " 'b端产品',\n",
       " '用户增长',\n",
       " '策略产品',\n",
       " '数据分析',\n",
       " '内容产品',\n",
       " 'C端产品',\n",
       " '增长黑客',\n",
       " '私域增长',\n",
       " '新零售',\n",
       " 'to C',\n",
       " '商品管理',\n",
       " '产品企划',\n",
       " '商品运营',\n",
       " '医院器械',\n",
       " '泌尿外科',\n",
       " '游戏产品',\n",
       " 'MMO游戏',\n",
       " 'to C',\n",
       " '产品优化',\n",
       " '二次元在研',\n",
       " '项目管理',\n",
       " '市场营销',\n",
       " '产品管理',\n",
       " '产品开发',\n",
       " '市场洞察',\n",
       " '拓展培训',\n",
       " '团队管理',\n",
       " '销售管理',\n",
       " '出差',\n",
       " 'CRM软件',\n",
       " '信息化项目',\n",
       " '软件行业',\n",
       " '咨询项目',\n",
       " '售前支持',\n",
       " '服务业',\n",
       " '批发/零售',\n",
       " 'IT/互联网/软件',\n",
       " '化工行业',\n",
       " 'CRM系统',\n",
       " '品牌策划',\n",
       " '客户端产品',\n",
       " '工具产品',\n",
       " '供应链产品',\n",
       " '基金产品',\n",
       " 'IT互联网',\n",
       " '金融理财/贷款',\n",
       " 'to C',\n",
       " 'to B',\n",
       " '产品设计',\n",
       " '移动端产品',\n",
       " '英语',\n",
       " '市场推广',\n",
       " '市场拓展',\n",
       " '渠道策划',\n",
       " '市场策划',\n",
       " '市场调研分析',\n",
       " '乙方公司背景',\n",
       " 'to B',\n",
       " '大客户',\n",
       " '无销售性质',\n",
       " '数据产品',\n",
       " '工具产品',\n",
       " '平台产品',\n",
       " '科研/技术服务',\n",
       " '数据分析',\n",
       " 'SQL',\n",
       " '竞品分析',\n",
       " '中央市场产品经理经验',\n",
       " '区域推广经验',\n",
       " '神外',\n",
       " '医生',\n",
       " '化妆品原料',\n",
       " '市场推广',\n",
       " '产品策划',\n",
       " '产品运营',\n",
       " '产品规划',\n",
       " 'PS',\n",
       " 'PPT',\n",
       " '研讨会',\n",
       " '活性物',\n",
       " '护肤品',\n",
       " '硬件产品',\n",
       " '硬件系统集成',\n",
       " '汽车行业',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '市场调研',\n",
       " '交互设计',\n",
       " '产品规划',\n",
       " '游戏行业',\n",
       " '产品设计',\n",
       " 'AI人工智能产品',\n",
       " 'AI人工智能产品',\n",
       " '内容产品',\n",
       " '商业产品',\n",
       " '人工智能',\n",
       " 'to C',\n",
       " 'IT互联网',\n",
       " 'to G',\n",
       " '产品规划',\n",
       " '产品设计',\n",
       " '需求分析',\n",
       " '策略产品',\n",
       " '平台产品',\n",
       " '数据产品',\n",
       " '计算机软件',\n",
       " '产品优化',\n",
       " '团队管理',\n",
       " '用户研究',\n",
       " '产品设计',\n",
       " '数据挖掘',\n",
       " '数据分析',\n",
       " 'b端产品',\n",
       " '用户增长',\n",
       " '策略产品',\n",
       " '数据分析',\n",
       " '内容产品',\n",
       " 'C端产品',\n",
       " '增长黑客',\n",
       " '私域增长',\n",
       " '新零售',\n",
       " '化妆品',\n",
       " '消费品',\n",
       " '产品开发',\n",
       " '产品策略',\n",
       " '爆品',\n",
       " '母婴',\n",
       " '美妆',\n",
       " '产品策划',\n",
       " '电商',\n",
       " 'to C',\n",
       " '商品管理',\n",
       " '产品企划',\n",
       " '商品运营',\n",
       " '医院器械',\n",
       " '泌尿外科',\n",
       " '品牌策划',\n",
       " '市场营销',\n",
       " '产品管理',\n",
       " '产品开发',\n",
       " 'to C',\n",
       " '游戏产品',\n",
       " 'MMO游戏',\n",
       " 'CRM软件',\n",
       " '信息化项目',\n",
       " '软件行业',\n",
       " '咨询项目',\n",
       " '售前支持',\n",
       " '服务业',\n",
       " '批发/零售',\n",
       " 'IT/互联网/软件',\n",
       " '化工行业',\n",
       " 'CRM系统',\n",
       " '市场洞察',\n",
       " '拓展培训',\n",
       " '团队管理',\n",
       " '销售管理',\n",
       " '出差',\n",
       " '产品优化',\n",
       " '二次元在研',\n",
       " '项目管理',\n",
       " '增长产品',\n",
       " '数据分析',\n",
       " '客户端产品',\n",
       " '工具产品',\n",
       " ...]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "labels_list = [j  for i in df_PM['job.labels'].apply(lambda x:eval(x)).values.tolist() for j in i]\n",
    "labels_list"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "34ecbedf-c7b9-4f56-b03a-96699df68a5c",
   "metadata": {},
   "source": [
    "# 统计每个label的个数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "c2315d23-29e8-43d3-b7f4-03524731e0ca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('产品策划', '42'),\n",
       " ('工具产品', '42'),\n",
       " ('产品开发', '42'),\n",
       " ('竞品分析', '21'),\n",
       " ('增长黑客', '21'),\n",
       " ('IT互联网', '42'),\n",
       " ('市场拓展', '21'),\n",
       " ('产品企划', '21'),\n",
       " ('乙方公司背景', '21'),\n",
       " ('数据分析', '76'),\n",
       " ('护肤品', '21'),\n",
       " ('用户研究', '42'),\n",
       " ('平台产品', '42'),\n",
       " ('数据产品', '42'),\n",
       " ('区域推广经验', '21'),\n",
       " ('产品管理', '21'),\n",
       " ('CRM系统', '21'),\n",
       " ('市场推广', '42'),\n",
       " ('化工行业', '21'),\n",
       " ('供应链产品', '21'),\n",
       " ('客户端产品', '21'),\n",
       " ('美妆', '21'),\n",
       " ('C端产品', '21'),\n",
       " ('内容产品', '42'),\n",
       " ('增长产品', '13'),\n",
       " ('人工智能', '21'),\n",
       " ('产品运营', '21'),\n",
       " ('产品规划', '63'),\n",
       " ('中央市场产品经理经验', '21'),\n",
       " ('拓展培训', '21'),\n",
       " ('移动端产品', '21'),\n",
       " ('私域增长', '21'),\n",
       " ('批发/零售', '21'),\n",
       " ('销售管理', '21'),\n",
       " ('游戏行业', '21'),\n",
       " ('市场调研分析', '21'),\n",
       " ('母婴', '21'),\n",
       " ('渠道策划', '21'),\n",
       " ('PS', '21'),\n",
       " ('市场营销', '21'),\n",
       " ('化妆品', '21'),\n",
       " ('出差', '21'),\n",
       " ('软件行业', '21'),\n",
       " ('金融理财/贷款', '21'),\n",
       " ('电商', '21'),\n",
       " ('基金产品', '21'),\n",
       " ('计算机软件', '21'),\n",
       " ('硬件系统集成', '21'),\n",
       " ('活性物', '21'),\n",
       " ('需求分析', '42'),\n",
       " ('数据挖掘', '21'),\n",
       " ('医院器械', '21'),\n",
       " ('PPT', '21'),\n",
       " ('b端产品', '21'),\n",
       " ('项目管理', '21'),\n",
       " ('英语', '21'),\n",
       " ('产品优化', '42'),\n",
       " ('二次元在研', '21'),\n",
       " ('团队管理', '42'),\n",
       " ('产品策略', '21'),\n",
       " ('IT/互联网/软件', '21'),\n",
       " ('SQL', '21'),\n",
       " ('品牌策划', '21'),\n",
       " ('产品设计', '105'),\n",
       " ('汽车行业', '21'),\n",
       " ('研讨会', '21'),\n",
       " ('硬件产品', '21'),\n",
       " ('CRM软件', '21'),\n",
       " ('用户增长', '21'),\n",
       " ('售前支持', '21'),\n",
       " ('市场洞察', '21'),\n",
       " ('新零售', '21'),\n",
       " ('消费品', '21'),\n",
       " ('信息化项目', '21'),\n",
       " ('市场调研', '21'),\n",
       " ('商品运营', '21'),\n",
       " ('医生', '21'),\n",
       " ('科研/技术服务', '21'),\n",
       " ('to C', '84'),\n",
       " ('服务业', '21'),\n",
       " ('泌尿外科', '21'),\n",
       " ('商品管理', '21'),\n",
       " ('交互设计', '21'),\n",
       " ('神外', '21'),\n",
       " ('大客户', '21'),\n",
       " ('商业产品', '21'),\n",
       " ('to G', '37'),\n",
       " ('咨询项目', '21'),\n",
       " ('to B', '58'),\n",
       " ('游戏产品', '21'),\n",
       " ('无销售性质', '21'),\n",
       " ('MMO游戏', '21'),\n",
       " ('AI人工智能产品', '42'),\n",
       " ('化妆品原料', '21'),\n",
       " ('策略产品', '42'),\n",
       " ('爆品', '21'),\n",
       " ('市场策划', '21')]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "labels = [(i, str(labels_list.count(i))) for i in set(labels_list)]\n",
    "labels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "97d060d6-a251-4131-b008-bf6ca49315e6",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.16"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
